package com.example.mapper.one;

import com.example.pojo.GraduateInfo;
import com.example.pojo.Instructor;
import com.example.pojo.Joborient;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface GraduateMapper {
    List<GraduateInfo> getGraData(@Param("gradeId")Integer gradeId, @Param("majorId")Integer majorId, @Param("teamId")Integer teamId, @Param("sno")Integer sno, @Param("sname")String sname, @Param("instructor")String instructor);
    List<Instructor> getInstructor(@Param("gradeId")String gradeId, @Param("majorId")String majorId, @Param("teamId")String teamId);
    Integer deleteGra(@Param("sNo")Integer sno);
    String querySname(@Param("sNo")Integer sno);
    int addGra(GraduateInfo graduateInfo);
    String getAssistantByGradeId(@Param("gradeId")Integer gradeId);

    int updateGraById(GraduateInfo graduateInfo);

    int getInstructorByName(@Param("instructorName")String instructorName);

    int getGraCount(@Param("sNo")Integer sno);

    List<Integer> queryJobOrient(@Param("gradeId")Integer gradeId);

    List<Map<String,Object>> queryEmployNum(@Param("gradeId")Integer gradeId);

    List<Map<String,Object>> queryMonthNum(@Param("gradeId")Integer gradeId);

    List<Map<String,Object>> querySalary(@Param("gradeId")Integer gradeId);

    Double getEmployRate(@Param("gradeId")Integer gradeId);

    Double getWorkNum(@Param("gradeId")Integer gradeId);

    Double getCounterpartRate(@Param("gradeId")Integer gradeId);

    List<Map<String,Object>> getCityNum(@Param("gradeId")Integer gradeId);

    List<Map<String,Object>> getIndustry(@Param("gradeId")Integer gradeId);

    List<Map<String,Object>> getInternshipPosition(@Param("gradeId")Integer gradeId, @Param("industry")String industry);

    Integer queryInstructorId(@Param("instructorName")String instructorName);

}
